Here is an example of ABAP program which will count number of
records in a table defined by the user during runtime.
This is a very simple example to show how Dynamic Open SQL can be
implemented within the program, specifically in SELECT statement. In this
example the program will calculate the number of records from the table which
the user inputted. This program is far from perfect and no exception or error
handling has been implemented.
The table name that the user inputted will be kept in a variable or
parameter called TBLNAME (Line 2). During runtime, the program
will display selection screen which allows the user to input a table name. As
the default, the program will automatically input SPFLI as the
table name.
After the user pressed Execute or F8 button, the value of SPFLI
will be kept in a variable called TBLNAME which will be used to
determine the table name of the SELECT statement. In this program, the SELECT
statement will COUNT how many records are in the table (Line 4).
